About manager

This author has not yet filled in any details.
So far manager has created 242 blog entries.

Multi-Criteria SUMIF

Multi-criteria SUMIF I use SUMIF to sum a range based on one condition. Is there a way to sum a range based on two or more conditions? By Neale Blackwood One way is to use SUMPRODUCT. The following formula will sum the range C1:C10 based on the contents of A1:A10 and B1:B10. Cell E1 [...]

2017-03-08T03:53:56+00:00 Arrays|

 Dynamic Headings

Dynamic Headings Is there a way to change headings based on a cell that has the current month? By Neale Blackwood Yes. If cell A1 contains Feb 03 as a date, then the following formula will create the heading - Report for Feb 03. ="Report for " &TEXT(A1, "mmm yy") Note the space after [...]

2017-03-08T03:53:56+00:00 Functions|